<?php
/*
    Copyright 2010 Justin Lipton, Jonathan Rosenberg
    
    This file is part of MediaList.

    MediaList is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    MediaList is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with MediaList.  If not, see <http://www.gnu.org/licenses/>.
*/

$name=$_GET["name"];

$db = new mysqli("localhost", "root",null , "DB");
$stmt = $db -> prepare("SELECT Showname FROM Shows WHERE ShowName LIKE ? ORDER BY ShowName ASC");
$name='%'.$name.'%';
$stmt -> bind_param("s", $name);
$stmt -> execute();
$stmt -> bind_result($row["Showname"]);

while($stmt->fetch())
{
    echo "<a href=show.php?showname=".$row["Showname"].">".$row["Showname"]."</a></br>";
}


?>

